The SQL Server documentation team welcomes your documentation feedback. We view and investigate all documentation issues but do not answer technical support questions here. For help with technical issues not related to documentation, see Getting Assistance with SQL Server.

If it is possible, submit feedback to us in English.

1.0 Introduction to the Data Mining Add-Ins for Office 2007

The Microsoft® SQL Server™ Data Mining Add-Ins for Office 2007 help you derive patterns and trends that exist in complex data, visualize those patterns in charts and interactive viewers, and then generate rich, colorful summaries for presentation and for business analytics. This document describes how to obtain and install the Data Mining Add-Ins for Office 2007. The Data Mining Add-Ins for Office 2007 must be used with Microsoft Office Excel 2007 and Microsoft Office Visio 2007.

Important:
The Data Mining Add-Ins for Office 2007 require a connection to an instance of SQL Server Analysis Services. These add-ins cannot be used with SQL Server 2000 Analysis Services, because it requires the algorithms and other data mining services provided in SQL Server 2005 Analysis Services.

After you have downloaded the add-ins, you can find additional information about how to use the Data Mining Add-ins for Office 2007 in the Help that has been provided in the installation package. If you installed the add-ins in the default location, the path of the Help file is as follows:

c:\Program Files\Microsoft SQL Server 2005 DM add-Ins\DMAddins_Office2007.chm.

For more information about getting started, see Data Mining Tools Overview (Data Mining Add-Ins for Office 2007).

[Top]

1.1 Installation Requirements

To use the Data Mining Add-Ins for Office 2007 with an instance of SQL Server Analysis Services, the instance must have been upgraded to Microsoft SQL Server 2005 SP1 or higher.

For more information about installation requirements, see the Microsoft SQL Server 2005 Data Mining Add-ins for Office 2007 page on the Microsoft Download Center.

Disk Space Requirements

During installation, you can select the add-ins to install, including an Excel worksheet containing sample data that might be useful in constructing different types of data mining models.

The following table describes the disk space required to install the Data Mining Add-Ins for Office 2007:

Disk space required (MB)	Add-in name	Installation
4	Table Analysis Tools for Excel	Default
30	Data Mining Client for Excel	Optional
2	Data Mining Templates for Visio	Optional
1	Server Configuration Utility	Default
1	Documentation	Default
2	Sample data	Default

System Requirements

Your computer must meet the following requirements to successfully install the add-ins.

Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2.
The Microsoft .NET Framework 2.0.
Microsoft Office 2007 with .NET Programmability Support.
40 MB of available hard disk space.

Note:
If you install the Table Analysis Tools for Excel or the Data Mining Client for Excel, verify that the .NET Programmability Support component is installed. The default install of Microsoft Office Excel includes this component.

Note:
If you install the Data Mining Templates for Visio, verify that the .NET Programmability Support component is installed under Microsoft Office Visio. The default install of Microsoft Office Visio includes this component.

[Top]

1.2 Uninstalling or Modifying the Add-ins

To remove the add-ins

In Control Panel, click Add or Remove Programs.
Select Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007.
Click Remove.

After installation, you can change the installed options, to add or remove add-ins. The Table Analysis Tools for Excel are installed by default, but you can add the Data Mining Client for Excel, or the Data Mining Templates for Visio.

To modify the add-ins

In Control Panel, click Add or Remove Programs.
Select Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007.
Select the add-ins you want to add or modify, and click Next.

1.2 Additional Configuration

The first time that you open one of the Data Mining Add-Ins for Office 2007, the Getting Started utility opens and guides you through the process of configuring the add-in to connect to an instance of SQL Server Analysis Services. The utility also assists you in downloading an evaluation version of SQL Server 2005 if you do not have access to an existing instance.

If the utility does not start automatically, you can run it by doing the following:

To run the Getting Started utility

Click Start, point to Microsoft SQL Server 2005 DM Add-ins, and then select Getting Started.

If you already have access to an existing instance of SQL Server 2005 Analysis Services, you can configure the server to allow data mining by using the Server Configuration Utility. This utility is available as part of configuration when you run Getting Started, but you can also start it at any time by doing the following:

To run the Server Configuration Utility

Click Start, point to Microsoft SQL Server 2005 DM Add-ins, and then select Server Configuration Utility.

For more information about the Getting Started utility and the Server Configuration utility, see Setup and Configuration (Data Mining Add-ins for Office 2007).

[Top]

2.0 Updated Information

For more information about the Data Mining Add-Ins for Office 2007, or new data mining features, see the Microsoft SQL Server: Data MiningMicrosoft SQL Server: Data Mining Web site.

[Top]

3.0 Obtaining the Data Mining Add-Ins for Office 2007

To obtain the Data Mining Add-Ins for Office 2007, see the Microsoft SQL Server 2005 Data Mining Add-ins for Office 2007 page on the Microsoft Download Center.

[Top]